class CreateClients < ActiveRecord::Migration
  def self.up
    create_table :clients do |t|
      t.string :first_name
      t.string :middle_name
      t.string :last_name
      t.string :spouse_first_name 
      t.string :spouse_last_name
      t.string :spouse_middle_name
      t.string :address1
      t.string :address2
      t.string :city
      t.string :state
      t.string :country
      t.string :zip
      t.string :home_phone
      t.string :office_phone
      t.string :cell_phone
      t.string :spouse_contact_phone
      t.string :email_address
      t.string :spouse_email_address
      t.date   :regitration_date
      t.integer :clientstatus_id
      t.integer :clientcategory_id
      t.integer :foundmode_id
      t.string :other_findmode
      t.integer :county_id
      t.integer :community_id
      t.string :contact_sales_person
      t.integer :created_by_user_id
      t.timestamps
    end
  end

  def self.down
    drop_table :clients
  end
end
